USE [BD_Taller]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF OBJECT_ID('dbo.spConsultarArticuloDesc') IS NOT NULL
  DROP PROCEDURE dbo.spConsultarArticuloDesc;
GO

CREATE PROCEDURE spConsultarArticuloDesc
    @descripcion varchar (255)
AS
BEGIN
	SELECT *
	FROM   dbo.Articulo
	WHERE  UPPER(descripcion) = UPPER(@descripcion);
END
GO
